SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045300 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045300 [ RunTime:0.002472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007903,349793,652161,887791,522178,636271,243139,407965,768982,776317,1000056,863321,808332,145035,386454,823776,213767,550059,260411,498381,216492,150588,11286,795180,897852,1008422,562165,540054,531031,549092,287748,1038693,778889,831930,263574,563282,43891,38771,713833,207754,552826,512262,109027,408928,270133,584532,754875,773964,400482,958775,677516,37181,580642,825211,124888,10981,598119,376060,627083,405527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008044s ]