SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196890 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196890 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537528,891216,359786,923797,768517,982393,196767,372844,666619,632528,347351,755483,815030,302462,505526,337682,688461,406836,20096,290590,188523,298113,1008629,737649,975815,717950,15932,244038,892456,481265,843769,850782,648823,722674,722311,859655,665197,573320,187166,933980,377612,319280,58330,275836,745111,424412,523469,659371,457884,1046426,986376,813481,314632,191225,981142,753386,49609,591810,843152,841725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]