SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005712s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020517 LIMIT 1 [ RunTime:0.003732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020517 [ RunTime:0.004630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230605,62929,1005816,305445,639222,796340,89156,364463,151890,997486,481454,822547,766113,982664,612876,1047135,639477,768210,791924,934113,1022862,916084,465381,256972,463893,58266,929771,312164,240805,458663,591713,114186,277306,433240,660933,47063,1026084,912181,285671,542337,911900,915389,513407,1010059,471764,251310,846688,60357,421702,337109,285103,993740,997613,447648,352609,224366,645680,128007,472347,331672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002157s ]