SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103567 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103567 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401748,669609,1013079,229624,458330,1968,428933,670218,62114,417811,374677,339023,613826,219966,973599,786335,541672,837791,279022,693143,765021,330401,328795,750565,1041175,899779,67364,661536,973487,246094,743731,476586,93773,381881,560345,430548,381070,1010,921803,1045148,745239,36012,955032,549941,64905,10967,1026114,572680,962235,756937,1042899,774709,679405,375892,964015,979595,30425,167608,443580,71053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002987s ]