SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045521 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045521 [ RunTime:0.005717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312208,15162,737936,371724,187664,51547,339576,1045533,568672,302770,304436,444548,582227,408661,405059,395340,636319,1008539,182716,229806,1010142,682502,932659,165857,510465,224468,484678,495421,714456,252004,570367,578071,760475,590165,625578,969479,210991,918285,510636,504080,843711,59710,827211,345742,904924,640890,960643,355092,9009,860353,961144,203034,39748,589490,636073,378500,642386,26342,477424,1015950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]