SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517001 LIMIT 1 [ RunTime:0.000868s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517001 [ RunTime:0.002727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292295,379464,64609,321035,738774,761462,153183,759237,140654,625837,7617,460184,620178,823839,36860,832058,932996,493261,246394,676185,644293,160570,634976,482596,238548,232154,716436,792452,636690,1045830,891012,199596,142745,254169,567981,352182,344061,354370,645901,100451,757583,447875,185319,641757,959812,857470,733196,887682,254839,717292,341393,891251,237986,1040785,678875,689554,1046339,665512,427405,780953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]