SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518531 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518531 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815961,998904,850535,835486,840454,370973,993068,372738,152125,901486,623314,928313,982200,39680,21850,735814,830397,755968,968793,153888,220190,176616,396580,649174,602672,312926,384574,312064,620334,40748,903641,48249,138679,508794,646642,294274,218588,710965,438685,342532,952473,528922,299669,145119,448679,57430,380117,455776,8608,932392,1041218,947755,86830,95543,884542,484896,1034584,195483,860205,340243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]