SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536013 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536013 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426904,83845,436436,1006308,702103,260549,202190,891180,90406,307041,726601,490016,821378,624832,675723,952640,762695,1037585,366770,682462,670007,1024312,678850,766918,146125,350672,574149,305757,910439,1034715,33487,458129,784548,327926,339476,668700,712542,977151,240354,91625,1035693,609155,999784,173585,850779,964110,614830,707648,949666,1038567,132667,513948,116062,203654,447729,111219,725658,962888,274837,752297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]