SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001645s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466429 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466429 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815830,308090,661326,971882,380099,1022498,194338,566304,677824,510619,140255,289427,547478,1009580,678930,78793,922509,413491,862631,236121,828419,615255,827373,1029298,788158,701337,768493,278666,519608,767844,329550,304835,683801,200194,396674,805177,502217,404796,34890,160941,414419,709651,544433,629094,534852,600992,813579,212657,754260,571324,362953,499226,882294,857851,438564,663097,208153,898501,240627,507910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]