SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104028 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104028 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651686,71571,1004121,851757,677562,323786,220235,268384,58512,633991,450209,976390,1030244,534144,142800,816523,834114,261300,195961,640511,584519,33783,182406,317746,391683,941286,811060,554243,969180,800191,2218,399096,119294,694209,684987,1046441,483759,424635,780441,724328,283050,429792,948444,629671,452573,199192,174379,835776,663937,889367,483155,358579,588762,543183,474206,265220,308881,302919,909445,349656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002318s ]