SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971163 LIMIT 1 [ RunTime:0.000807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971163 [ RunTime:0.004535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41612,794807,618521,797318,288118,1006930,594440,186426,739868,12306,957476,238304,57513,569067,572747,784834,222788,482917,213899,445308,340169,1039405,258290,457429,210112,650704,41280,18469,764136,111313,318061,296157,526613,891448,729756,577176,719944,798251,1045325,195652,380375,928820,658273,74728,1044102,4338,886145,398393,17171,797943,892265,140323,892419,835655,249517,472081,125766,641919,272520,676032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]