SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345506 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345506 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40060,99176,745803,938574,671986,544219,713222,920991,428751,150074,578941,360727,395958,733808,36144,349776,358717,277083,459260,782491,971744,1001750,994999,619553,324245,993973,173209,244301,207890,403686,692797,170649,564672,686992,488424,486800,311633,592880,475138,928400,983112,470204,789335,987257,439753,804447,877877,23494,999764,851625,1028736,619605,421447,839486,776159,249455,513595,778673,845233,894405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]