SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508201 LIMIT 1 [ RunTime:0.001064s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508201 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618407,770987,682520,1045447,1039756,1042997,707335,67374,613443,165212,186634,181035,486318,309036,467604,1010651,838390,912244,774989,660178,314538,368410,926999,914540,828488,306465,443256,896301,918806,752841,742743,65424,752464,673184,339322,531003,513198,456640,135964,377297,858586,341060,345432,568354,445473,333077,382009,187059,680908,825300,494083,543445,587569,230421,442617,642689,513610,437532,424453,728278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.035919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003733s ]