SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498328 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498328 [ RunTime:0.002515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24504,363757,731951,800975,203943,917387,222560,473121,563616,259885,23984,168062,763751,70748,719091,824233,696479,321161,254835,252751,772027,728579,84029,606958,284251,501043,171024,515908,883767,813390,840665,51352,626225,237602,645318,947552,312122,8888,191280,526765,527915,707091,907270,145972,589293,153132,446779,851094,796530,927532,607421,498798,646055,277534,1015685,255911,191616,134709,259646,88315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]