SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30503 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30503 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848374,46526,983544,632575,572174,445010,44842,983072,185288,472935,312605,86720,838429,374706,217562,991564,448791,670588,871159,224291,148530,933878,468111,504299,334921,156809,268575,408277,914825,931753,193894,795312,118814,256535,340887,671114,381677,189806,812679,187247,1031348,352100,390197,979629,476638,149066,191495,626483,464924,279616,654019,839537,939360,800797,463127,460217,48041,338095,548969,545851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]