SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804514 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804514 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14598,625587,1045547,173265,593461,671598,448760,214537,141702,969248,856572,496629,21823,1031068,448581,547169,268943,836217,1046628,813449,818858,406659,333787,715294,583932,154738,885743,420530,115956,167022,254228,745791,360541,946297,926448,203875,323944,831231,197142,864724,903675,365604,443423,661636,692421,251718,430677,224423,308099,815977,186638,340572,6275,843826,336799,714431,309187,121390,137576,509788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]