SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388176 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388176 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042138,913213,426352,202901,523422,891995,829970,465566,194432,27332,256552,29105,681140,436950,244772,939043,111633,47326,960677,438048,501681,23022,820012,571824,877711,320119,201815,560080,235686,312298,75354,823120,367788,67839,774850,379245,375262,308184,344009,18061,900870,995830,483631,214105,722973,783544,1005510,834005,888788,304232,616655,908893,403194,892281,840996,477682,559775,148544,83021,238896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001143s ]