SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415458 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415458 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844151,1003500,332109,596402,377388,14791,852682,501436,925944,548050,587501,76275,349875,886751,341647,614854,901005,893687,249543,554736,637125,928795,430264,733836,525592,150456,251284,755448,25533,101482,991724,339755,780701,371455,86625,436646,598829,102439,77751,268734,738611,393903,696149,481430,755014,969616,859694,3742,36113,991701,646203,695583,952638,370670,113995,582662,592070,1029570,206406,893845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]