SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101915 LIMIT 1 [ RunTime:0.000984s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101915 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045762,847246,436032,342027,913852,911353,454916,717198,597960,364931,677297,421920,456358,661010,675682,644700,813396,598736,267495,258950,814204,767394,708465,861363,2799,585144,933884,57316,1003033,105062,948494,628493,941432,185855,183404,832112,221273,654810,420637,644333,899731,398157,809610,75977,465402,527619,338891,570805,226234,79474,331639,86422,673162,501667,262235,547123,543435,992483,619156,265615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]