SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402190 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402190 [ RunTime:0.003522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695015,643742,853334,10451,105138,421003,804012,1041034,927794,982747,309624,557867,132249,730208,6401,464477,906942,992817,608583,286682,549398,98047,973177,364368,646267,747713,905672,936647,262689,440343,263336,320450,187832,935175,625450,37544,1048849,264215,505974,980647,273059,1023847,894310,3522,375848,1028237,1048554,113880,21176,1002722,1017735,877356,441864,565770,471962,327605,325182,903985,76150,69837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]