SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452861 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452861 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368348,303096,1011379,860895,5087,51867,71908,749411,659586,884516,922227,107094,617773,387237,146607,33435,449673,431304,918351,878102,536701,728818,636127,417842,910063,785642,367005,404144,927081,506225,710271,181495,340558,970571,512738,465282,643829,1017420,159207,822606,670944,250679,584149,504077,652307,605160,987250,887117,493488,971677,721545,862176,21038,849003,360141,791148,874606,910996,413760,916333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]