SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469763 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469763 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835959,947383,731093,783899,131715,718037,323274,714888,737007,462293,117802,533771,878464,650915,322480,936454,827452,682251,1038854,924419,10960,669217,133666,554075,533128,867171,1033803,583404,907156,485024,515505,385638,316980,468259,230099,403861,200171,379065,134215,913035,210302,453454,576292,937475,550764,388720,485641,469929,811678,917534,299282,179310,367931,37178,985642,68382,380220,688200,822662,922355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]