SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295241 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295241 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99793,60681,444853,15874,360989,681663,413353,368705,441916,958437,816290,981880,759439,378642,278748,941354,947183,575138,842579,384641,1012086,369992,948440,438281,170327,96396,380324,82091,433276,870760,41924,608554,218772,500907,317466,756634,572011,742263,968642,441708,643364,508926,379500,949065,309894,557712,838814,293980,746054,842449,71337,702320,945913,755045,875448,957949,860432,763589,564259,688052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]