SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419281 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419281 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996005,396178,675080,320696,753038,731080,933923,698026,608217,191867,121023,63950,286715,345718,1003389,852528,123322,312588,262349,854348,114640,788176,488250,647021,987476,933079,188394,492294,74924,876584,659010,254674,691943,938512,72915,427322,401627,83455,280993,842509,558879,624200,222338,944381,536181,460130,855392,187617,916588,354880,167189,673451,242498,29976,207499,245538,721417,361080,789107,766644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]