SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14150 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14150 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740638,897334,1027238,643384,200059,754840,32221,966900,480777,25865,886531,441687,282292,28523,734027,994443,1008839,121473,735935,148760,576711,594014,392222,624303,944499,911399,372488,264496,619998,114230,310458,356508,42773,744205,482836,358709,176818,431044,76520,228788,1034851,451879,131735,639022,398160,524246,636565,514163,626437,153339,568573,510428,225308,361880,560142,158879,180055,743883,441865,14169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001196s ]