SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291441 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291441 [ RunTime:0.001403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401616,679054,167155,272940,381069,857041,740130,1011243,784221,59721,40943,375478,571071,14680,550105,457514,677721,203174,309592,397246,378130,345193,933685,35128,55074,862830,173433,679210,933765,340449,194269,815346,651683,353467,100304,275170,763685,1032683,952747,314782,987449,738691,131250,1033507,989547,890336,129265,938018,962545,129441,328173,910324,363021,902574,345946,48605,565651,950702,721466,968411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]