SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511075 LIMIT 1 [ RunTime:0.008110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511075 [ RunTime:0.004259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175121,598318,247465,109787,4757,674634,852200,628495,477745,903678,796561,805637,867909,913058,305750,757611,618829,535130,999291,586881,1007077,392772,1022662,874139,495087,260504,684246,590362,528539,687315,259386,297090,169789,152834,724065,519447,469290,604980,337833,78455,139496,750370,663572,933846,648313,656280,986480,569833,525466,953827,732336,1028370,210347,624065,403350,1039958,319659,284679,106383,182419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.013915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]