SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47105 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47105 [ RunTime:0.002986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292032,173639,212597,1000453,1027155,828884,155738,431554,968313,233276,240650,789182,362304,887849,4803,570533,317435,499858,334371,462231,280849,883776,928279,138096,999283,674000,672191,937279,359053,115193,1044776,664507,192546,564275,914793,178808,53233,885714,414637,863694,432969,1034001,288003,70668,558411,90127,832448,55427,1030809,592305,164041,202496,210866,985230,852143,622192,838596,890766,54142,400208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001720s ]