SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354823 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354823 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492507,43501,643074,766596,728923,462180,312962,230319,730197,1036500,617761,302540,196338,782418,764324,284273,53829,74226,953340,1027725,426894,782642,526019,628799,484826,802588,657141,144640,224427,97970,346456,248313,438190,399842,809474,431099,905925,756729,415150,109849,328979,244255,975652,438392,407020,220742,57869,263249,379901,315719,953176,485652,583493,216535,263502,160525,81315,608740,14063,976816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]