SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41913 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41913 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248207,986674,653974,435493,731002,126952,269038,217420,511701,67942,794170,891145,602427,607848,875499,1005799,25361,634465,922208,389140,835067,709707,59118,255131,364057,21859,415231,499455,40637,97527,767396,258173,65412,138307,814257,1043228,986362,229066,529597,426100,15666,139979,227066,202028,251962,893642,147145,116906,554741,371240,639575,527111,836645,591383,310706,715597,1010275,454398,423833,1028125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]