SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54546 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54546 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667353,912825,511198,673450,1036515,390165,151580,122745,10369,369752,64017,608415,791991,227146,758978,456010,755684,558854,95195,775523,899633,432853,669480,86057,1031949,993177,595779,323488,88041,783501,1036992,644374,783875,815937,802474,124806,145437,363303,831555,132380,716168,760262,154767,477248,160370,732414,500212,755469,210631,324711,637316,80800,899066,187802,724976,824000,324007,813738,111195,176626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]