SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 157180 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 157180 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452975,256943,85065,663123,19456,587519,752525,420234,478398,417803,780445,276496,139079,742887,787706,836124,530734,690984,642914,1019083,332374,961770,432394,20543,490265,57650,42240,471927,644795,438461,202851,358262,833640,293110,50017,355036,270603,589119,593294,2526,198518,176651,808502,222697,159289,527685,82460,911416,858119,5336,554656,429268,202173,767043,7651,103597,415766,444391,1026219,868494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 157180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 157180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]