SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106856 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106856 [ RunTime:0.004228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125553,258169,800459,684499,1039012,860404,110479,1017356,630744,402557,760215,355344,299269,689557,357535,96108,800833,641365,407494,628811,488779,674920,163937,1009373,27266,518986,1028145,196689,7361,297204,230402,622330,728565,791294,148455,361580,676047,846676,48938,312763,828673,1029076,490680,445504,876890,772788,1039942,864044,237669,220649,124378,902623,644781,659780,683265,692136,5021,860822,217577,513675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001066s ]