SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146954 LIMIT 1 [ RunTime:0.000875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146954 [ RunTime:0.003669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151318,205547,368813,953248,424885,437421,708564,374093,508655,992709,663791,156471,701464,98309,545064,568354,443613,101739,344136,92239,48158,810671,468099,905625,1026134,748819,243441,1014623,720682,202411,713977,820469,780574,809734,145096,762009,558647,136204,898493,163621,502430,189228,144899,440322,795197,61024,277227,450757,405373,785018,535375,909442,147944,363108,821657,351083,647323,1028969,952328,878810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]