SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357522 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357522 [ RunTime:0.003265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202761,51076,669813,28814,278537,779689,750741,950126,146797,660527,189710,834734,652071,644276,155356,997065,742522,678274,891905,483700,585845,327567,974920,411745,432020,181948,111361,702245,533839,314024,415693,924586,124209,593187,39156,402281,948520,445239,813542,153727,784021,404098,232785,898375,374638,57571,698431,460573,199900,913170,728523,326550,816490,268654,200819,947823,521184,147121,436237,673966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000830s ]