SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148574 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148574 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263324,519791,685824,63019,962674,559139,498015,520783,334682,1005153,624910,274456,661044,765744,455397,1008531,744444,102267,462585,882068,988314,433347,479317,985680,448291,756632,891969,688068,542317,827496,25526,325976,123424,597439,665440,434019,49073,700861,641450,488173,404614,373394,703941,473971,809117,122428,345556,875166,887598,513530,647833,738578,1040664,792321,27667,219051,606980,928289,804245,517216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004405s ]