SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504913 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504913 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718157,738859,6403,874543,993214,937399,271341,51775,206802,804810,996048,908988,355606,35916,489095,730395,820573,777594,356225,760093,168440,443261,764293,69622,807974,889910,549017,16723,848333,89472,627586,763119,991433,61262,295417,721896,1038720,877715,619733,943922,470696,1001495,540045,242354,636652,213974,500016,176714,50500,695285,156562,341858,660435,304784,793902,337450,1041182,193920,234301,908713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]