SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509735 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509735 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873226,272705,281748,713684,29492,858035,33919,674107,670663,42211,76964,1018222,48187,475318,1046983,783946,82669,651521,558147,441295,203131,343928,419530,782801,614113,777988,382266,901,353938,702734,137952,859099,1034234,297544,283613,761341,780356,541162,979992,707772,778173,539867,683070,230985,906329,1041208,707585,416257,371767,625114,417687,140706,533558,92532,901658,84794,289221,433325,285629,891466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509735 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509735 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]