SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019513 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019513 [ RunTime:0.003937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671363,965713,349726,578968,898946,948640,483336,692952,272468,198497,604201,878470,851453,875677,483982,217761,693827,600991,664943,457207,5108,157489,987182,449609,958047,165238,74092,431654,69044,494738,643769,415404,248312,576578,5104,934889,155220,975494,278248,492551,28358,27486,44209,357661,1048041,1009418,584712,618165,862357,291676,675215,563870,338288,6732,473426,1037324,678652,714079,331983,583019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004419s ]