SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286538 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286538 [ RunTime:0.004647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715968,1000573,28549,75362,818653,73889,356759,6215,223182,78753,848240,40488,802957,981525,294067,144284,517535,565861,777530,572001,160068,524513,150506,693053,657377,740789,738541,603233,298221,62280,1004433,461392,242063,1043439,935110,330605,187257,872904,796862,641657,916028,832184,688453,793592,230525,955268,847545,54053,803276,1032019,849326,108433,78623,146872,480454,689007,667178,377560,490974,813739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]