SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841998 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841998 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544354,710254,709785,758996,899156,88497,728235,219934,196166,149497,293546,606808,654276,287307,259391,910733,999264,417214,844578,70238,416780,28482,476700,621414,536454,174939,24065,149225,989277,750764,334679,943152,379678,985926,789299,442233,428750,507696,603522,243859,344185,319421,511512,982556,560198,481943,75557,484439,784668,143776,664939,226706,436834,607711,597153,961217,83725,557519,855615,705357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]