SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012506 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012506 [ RunTime:0.005206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137953,336024,451602,900201,895985,799299,749041,33073,854319,74992,759792,898069,1030084,75310,767868,724664,341392,732793,288794,287072,259849,1023596,764663,578048,469781,427247,741128,441898,820324,633820,131955,581989,551008,852899,475781,851652,208786,660202,207489,373304,845532,721393,953175,854834,486693,87602,903010,695016,746488,41190,623572,403700,103764,442209,473668,894223,766724,719430,607668,846749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]