SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002746s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045899 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045899 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455108,649197,472894,597251,493518,653132,776403,421725,390035,926322,43015,335450,158228,368752,227761,911416,651851,874114,777959,83644,879890,958439,87821,369713,415003,962862,1018376,249446,7198,243748,488308,887623,95539,663880,15540,437388,228086,111169,1031883,312325,733415,171361,397006,643461,349034,528397,71954,820590,1008264,582581,199147,627962,238614,685768,80449,984247,534395,13798,181242,949963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]