SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105373 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105373 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18985,40079,332642,329048,297467,852526,65589,721097,928606,543785,821409,278843,834724,187589,779945,191672,690830,347166,605562,117919,536135,736612,231437,366767,80518,495825,429320,535991,665171,312973,554465,91883,1040475,586674,498417,891767,641542,739479,792030,921609,323137,418888,481780,827386,913505,440340,407924,781360,927748,1001705,221278,825242,341444,995815,641429,570672,129433,129356,313045,883838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]