SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472993 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472993 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019744,577436,838413,756100,828477,575050,344502,415920,690707,411305,610316,851961,966572,643551,242634,280341,452192,443200,33376,484461,179022,570399,20975,1012165,387693,911889,591167,640122,778275,338666,184372,33955,389879,94891,818299,954252,1025534,906732,496418,225951,538357,476906,938893,353369,674645,702554,865668,100232,289301,54979,670069,636616,81507,539784,54326,688808,311268,708369,210191,658070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]