SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29107 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29107 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690199,854964,718141,361764,806566,526760,112854,253465,707878,590887,150842,803467,779127,1032134,637075,265812,846610,591065,659770,189388,279621,182273,58519,933858,585425,277191,321269,948200,452363,580493,179765,157150,126347,100099,155170,679267,374692,888616,491752,745385,143440,353569,675674,911506,647072,780930,472651,1004396,579879,656698,298300,156165,213736,526802,534555,853231,298146,690172,426170,60945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]