SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518819 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518819 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126089,885736,131862,20739,541788,131332,1013085,38969,31872,869741,567381,508869,383117,190672,218258,223951,653881,357824,500011,960930,599840,287796,294026,138250,304389,926542,547345,628235,872267,399703,974156,165420,834898,810497,954733,94757,227407,797790,656767,740785,370182,131356,380769,313258,548275,222453,113084,106636,405949,894467,323461,1000582,522161,184603,551861,408903,606940,571535,579440,704711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]