SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54043 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54043 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419947,1017508,694711,996587,1019403,43270,639914,906487,829407,110914,625367,988765,505182,184751,315581,608394,544997,322004,236520,33411,1022308,926084,711208,714938,739952,507543,177376,450996,847976,723888,214919,481993,356686,73185,443998,323430,852117,139409,675852,938103,19412,233182,180511,826353,466386,281806,725939,195405,562208,522430,14815,689554,437167,344775,261204,969648,499580,189293,733970,145942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]