SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438481 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438481 [ RunTime:0.002816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983892,812125,69556,803349,924400,950398,813240,190540,747080,871751,30082,300675,285046,686505,868410,563880,855860,802367,249770,719567,931512,1046929,914639,484137,736046,229339,950523,817038,321547,580895,334660,1003221,35476,275449,644759,918425,843810,349460,947403,543968,217835,820107,163464,1029511,1037268,946747,495349,862293,843211,283446,775396,898218,461750,195579,322484,371735,91545,356183,592732,595574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]