SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36166 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36166 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706349,363076,281761,902760,1037679,168244,54056,789617,908163,989219,1045567,800845,654117,596662,829109,472924,111792,411664,821429,211701,577334,51149,30067,199944,155189,382738,284484,63891,611195,1043694,824988,185851,50475,932143,476335,299301,91122,293661,462142,196045,791987,312519,463503,961760,613585,258520,108244,547561,1018850,487032,748715,1026153,579734,350759,803346,849671,795557,488620,549970,487990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]