SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506239 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506239 [ RunTime:0.003233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20386,200950,438161,856069,193596,160535,873079,963812,426873,914266,191649,309861,516343,545183,25314,201109,844891,747516,860395,103998,872743,936068,759999,542483,340514,630073,925646,730420,305132,15316,748559,755668,532732,397922,661001,836094,1027522,860600,365943,908954,439736,341261,540365,645520,729688,904380,467585,446193,158758,262751,686528,73994,898843,504886,286182,1003168,638591,394285,75907,302758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]