SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331743 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331743 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278662,100896,184825,758648,918400,200695,815237,320738,605189,984066,102240,765415,400523,490912,664620,965485,821535,772460,356893,949740,893211,585373,578919,685320,307647,116109,726966,772231,819334,148805,173856,911903,731702,623694,258710,449313,68718,695201,269898,334710,5382,835512,845896,74558,151018,253340,133695,477541,86347,479998,639629,871785,272424,492465,775915,839070,770552,459241,205815,699873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]