SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425828 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425828 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579200,271782,118274,489430,294364,331578,329702,117138,466458,342424,356571,944999,629170,261066,109224,302807,802599,16489,965855,515201,286937,661651,90048,455780,684743,928287,724959,145752,293923,684781,1028091,774504,104340,670155,564603,50071,204371,489571,331006,1016076,813045,166,855725,986618,514115,185902,483026,711100,970463,1017180,71047,919025,124586,736307,929860,125598,504728,382603,992429,867826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]