SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105674 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105674 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694155,756503,898895,788059,80203,387805,802427,119701,775874,797638,98000,39055,397856,584351,385778,409073,405353,694684,818313,777310,895315,517241,565852,179445,235924,894442,549562,853662,420464,172473,868984,639423,146302,988704,699072,234533,695662,999677,220780,157275,622026,953589,858320,790749,73315,795697,642665,1047031,292864,863842,674635,202033,54462,796474,233728,57120,732854,607464,329415,1005075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]