SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012262 LIMIT 1 [ RunTime:0.000779s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012262 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459680,82609,918047,281962,628118,771552,990474,875357,1006438,1023585,880303,196265,346857,768988,287959,256407,335138,94182,108766,128599,74631,524480,763047,139413,868732,885409,539601,434379,617570,211025,495140,998300,354360,380476,503348,585213,852713,955478,934333,252052,317301,673438,506491,703364,674927,916469,9172,632770,168718,806760,820597,41927,257239,721113,118448,302002,789949,694398,847102,156290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]