SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 896300 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 896300 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660934,336589,921138,297587,403852,681493,235194,1014932,985218,893822,283236,757498,509521,450323,694471,79254,536393,530530,339099,961045,310477,1029681,797098,243208,457736,710067,468436,20634,338749,870173,684869,852094,101458,967813,549114,281119,495588,293959,561671,155003,480443,650327,490943,1021257,549496,25169,523066,249849,250040,814034,361191,494103,191061,218767,580502,723960,238564,360993,106342,386604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 896300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 896300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001757s ]