SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429836 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429836 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018701,11699,812401,336188,1026615,396135,57004,657941,755106,946347,305675,163632,143490,304863,232012,210521,122530,205741,818510,62764,188352,713035,915169,694204,385157,530961,343092,50559,1018942,148379,21181,52732,815589,758246,842711,694864,862484,959855,702697,731019,156947,689028,679775,953959,809569,16555,537461,774296,696279,180524,337251,453186,418380,141334,90629,199970,826906,635803,987116,435370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]