SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376581 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376581 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29390,864243,953282,795785,461953,957644,551153,250679,791445,310130,716728,307675,560199,136415,209108,528948,220905,219584,783776,349250,516368,349921,768148,376829,792529,584187,797339,273086,988842,989874,889405,43055,664744,53647,440409,855502,553994,644126,958822,230691,884021,515002,731527,1027837,770982,184337,665268,588827,542368,139320,359788,685884,89115,7929,951666,568767,183777,606674,994674,632354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001797s ]