SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482491 LIMIT 1 [ RunTime:0.003599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482491 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192481,56467,711554,1001467,671164,135665,250891,42786,808387,248929,262382,410075,476824,729691,370757,123278,470884,1025553,195198,475336,422950,92796,628942,1043334,58914,668584,923468,379004,415412,315682,1007822,1044743,277648,104707,385629,725837,930875,259561,854042,240141,181495,440587,274409,848044,341395,492600,128451,486333,269916,785320,567585,449542,432128,171521,593050,799683,576150,1036049,565343,74653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001280s ]