SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526751 LIMIT 1 [ RunTime:0.000569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526751 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40652,449872,582569,552611,449294,57248,255348,372895,207905,1023884,406072,173388,435007,1022280,215855,565854,157388,974299,592737,836341,377039,891866,640474,531802,908190,346562,1014697,581258,417354,1002456,53411,287220,297063,402606,383035,521602,907502,684514,183289,318507,513824,1036405,522933,946539,496649,769709,47789,596781,157214,659941,980033,78292,241572,385909,471717,947591,166544,864008,325624,528578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]