SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300103 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300103 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457092,657080,889778,115750,91026,234341,288783,122876,636118,339869,355627,522565,910321,265305,664017,488657,790530,1002177,620446,487653,173543,355755,854799,463890,884340,689376,49948,270440,1028977,817369,968060,1027747,546515,636341,961589,632792,560938,173357,678202,262747,249452,744360,624007,495861,366426,561843,666569,110052,179863,448725,1022322,369703,58654,482560,951030,231784,611259,216589,58943,271076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]