SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004160 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004160 [ RunTime:0.003784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59111,492105,78535,579475,417916,240495,421566,306157,993297,786651,839583,428165,416400,837782,593083,22799,574739,738803,275259,721528,782853,147423,723968,577987,991911,488323,445648,794934,728323,671124,973304,612766,386536,593334,423704,947691,119176,328685,996783,142915,933135,845272,409029,594389,403234,982411,614225,222096,285581,262479,687620,105895,921259,993115,45027,75041,254739,764040,211490,516216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001007s ]