SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249436 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249436 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128017,921205,432918,1041496,656544,704532,624698,107627,111795,601713,714880,355694,530842,380145,144181,969890,840370,62233,697561,516486,394281,453753,804113,156003,672026,719690,502618,809625,160068,271865,235940,489093,785010,728788,991855,420959,658383,112632,167007,255778,609468,452689,327744,301946,1005280,298482,822097,929474,486710,700471,887182,190631,178647,562783,176866,1009400,309399,326016,37358,872537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]