SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30583 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30583 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627186,709453,563269,934577,480408,929498,922699,1041210,571745,386337,530930,465250,376881,707413,286913,885712,725377,823420,33063,223118,340014,154478,779909,341878,506335,409031,51968,137059,688638,1020168,390314,204078,628211,618003,865116,880868,194426,755659,617932,47940,431956,911073,608040,521415,851535,1000174,668561,657805,560040,722220,695083,377476,132093,843749,159747,350095,500997,213483,697547,518639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001547s ]