SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298329 LIMIT 1 [ RunTime:0.003285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298329 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52599,28759,901021,410507,955763,287103,799717,200396,1005648,231940,757257,117196,313762,307756,704759,488437,874490,561260,5792,1016428,638107,1038856,230021,986143,443895,494016,937298,409911,940635,195284,93495,607029,880372,408040,298960,82676,721977,822345,918291,905497,892004,705047,991998,364511,803460,1025723,486346,566235,139281,410174,214135,985949,652563,877124,314399,592018,958813,387339,905789,492105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]