SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981429 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981429 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237410,237701,1028424,713854,576396,173986,676273,221977,425101,479454,720347,426011,596163,523367,266874,981186,47564,164856,183506,335832,433838,867239,592042,328985,282587,1041292,880052,388373,555288,170930,1009411,338210,981951,364604,871925,1035299,52791,646242,718011,707349,929144,124271,656696,134898,655663,320482,273229,717729,3385,633908,574911,529432,582604,307701,887417,982716,351223,1040004,340201,409622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001664s ]