SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807300 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807300 [ RunTime:0.002771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014882,1028278,498682,469529,30202,193004,931884,7243,42115,412263,525736,926611,843410,703251,291901,39912,946548,1012755,975216,697415,734374,243071,726376,277018,935263,813395,148519,760474,767664,213394,385707,913238,345284,849329,204898,744720,401418,904570,821749,257364,674630,451836,807912,590988,707721,641163,443317,396078,155515,144997,998026,1044102,520518,379945,570939,799311,336937,74291,508156,475226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]