SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102971 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102971 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54223,626712,879325,881637,140858,502624,199189,93967,52507,142021,445134,464806,1028553,817381,264125,599499,877162,685595,372880,844995,122585,983185,74583,829809,535773,520054,497399,182030,545414,915854,543416,825024,786047,228238,914994,874441,566822,3525,144290,30103,395022,493685,795183,1000582,804585,251507,705541,990428,728276,910156,642659,131800,598157,722422,19280,894758,382383,600837,487131,50527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]