SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592505 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592505 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294010,536163,5920,151141,354090,353884,196479,549940,674838,436417,420916,232974,813247,759442,746880,384338,345417,559805,533355,328855,611499,141616,9589,511681,744675,27841,755480,353332,152561,1047060,217259,662436,15752,611182,460093,335104,416847,486368,107573,898215,941108,830508,528420,603135,886988,92544,244548,127152,1030114,12053,984709,952176,625480,693375,159077,649411,1015796,457846,163980,251397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]